Stored Procedures [dbo].[BAEOrderSuperProductAttributeLookupUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@OrderProductIDint4
@OrderSuperProductAttributeIDint4
@SortOrderint4
SQL Script
create procedure [dbo].[BAEOrderSuperProductAttributeLookupUpdate] @OrderProductID as
int,
    @OrderSuperProductAttributeID AS int,
    @SortOrder AS int
AS
    UPDATE OrderSuperProductAttributeLookup
    SET
    OrderProductID = @OrderProductID,    
    OrderSuperProductAttributeID =     @OrderSuperProductAttributeID,            
    SortOrder = @SortOrder            

    WHERE OrderProductID = @OrderProductID AND
    OrderSuperProductAttributeID = @OrderSuperProductAttributeID;

GO
Uses